CREATE VIEW [v_translate]
AS
SELECT tbl_translate.trans_id, tbl_translate.trans_group, tbl_translate.language_id, tbl_translate.trans_label, tbl_translate.trans_text, 
		tbl_language.language_code, tbl_language.language_desc
FROM tbl_language INNER JOIN
			tbl_translate ON tbl_language.language_id = tbl_translate.language_id

GO

